package com.huike.mapper.statistics;

import com.github.pagehelper.Page;
import com.huike.dto.ClientStatisticsDTO;
import com.huike.pojo.SubjectNum;
import com.huike.vo.ClientVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;
import java.util.Map;

@Mapper
public interface ClientStatisticsMapper {

    Page<ClientVO> selectClientList(ClientStatisticsDTO dto);

    @Select("select count(*) from statistics_clients where create_time<#{begin}")
    Integer selectClientTotal(LocalDate begin);

    Map<String, Object> selectClientTotalByDate(List<String> dateList);

    List<SubjectNum> selectSubjectNum(String beginCreateTime, String endCreateTime);
}
